package com.btpn.custody.common;

public class Query {

	public static final String TEMPLATE__CIF = 
		"AKTE_TERAKHIR_TANGGAL1, " +
		"AKTE_TERAKHIR_TANGGAL2, " +
		"ALAMAT_AHLI_WARIS1, " +
		"ALAMAT_AHLI_WARIS2, " +
		"CIF, " +
		"CUST_FULL_NAME, " +
		"ID_NUMBER, " +
		"INFO_AKTE_PENDIRIAN, " +
		"INFO_AKTE_PENDIRIAN2, " +
		"JABATAN, " +
		"JENIS_USAHA, " +
		"KOTA_AHLI_WARIS, " +
		"MOTHER_NAME, " +
		"NAMA_AHLI_WARIS, " +
		"NPWP, " +
		"PLACE_OF_BIRTH, " +
		"PROFESSION, " +
		"REK_BANK_LAIN1, " +
		"REK_BANK_LAIN2, " +
		"REK_BANK_LAIN3, " +
		"SIUP, " +
		"TANDA_DAFTAR_PERUSAHAAN, " +
		"HADDRESS1, " +
		"HADDRESS2, " +
		"HADDRESS3, " +
		"HADDRESS4, " +
		"HADDRESS5, " +
		"HPOST_CODE, " +
		"ADDITIONAL_INCOME, " +
		"BRANCH, " +
		"CURRENT_INCOME, " +
		"CUSTOMER_TYPE, " +
		"EDUCATION, " +
		"GENDER, " +
		"ID_TYPE, " +
		"HR_BUSSINESS, " +
		"HR_COUNTRIES, " +
		"HR_CUSTOMER, " +
		"HR_PRODUCT, " +
		"HUB_AHLI_WARIS, " +
		"HUB_DENGAN_BANK, " +
		"LAP_KEUANGAN, " +
		"LBU_GOL_NASABAH, " +
		"MARITAL_STATUS, " +
		"PARENT_COUNTRY, " +
		"PURPOSE, " +
		"RELIGION, " +
		"SOURCE_INCOME, " +
		"BIRTH_DATE, " +
		"ID_EXPIRED, " +
		"LAST_MAINTAINED_DATE, " +
		"OPEN_DATE, " +
		"TGL_AKHIR_TDP, " +
		"EST_TRX_NORMAL_CR, " +
		"EST_TRX_NORMAL_DB, " +
		"FREQ_TRX_CR, " +
		"FREQ_TRX_DB, " +
		"SALDO_NORMAL";
	
	// Copy data from DWH VI_CIF to CMT.TEMP_CIF 
	public static final String SELECT__VI_CIF = 
			"SELECT " + TEMPLATE__CIF + " FROM " + Constant.DWH_VW_CIF; 
	
	// get BUSS_DATE from VI_CMT_CIF
	public static final String GET_BUSSDATE = "SELECT BUSS_DATE FROM " + Constant.DWH_VW_CIF; 
	
	// Copy data from DWH VI_ACCOUNT to CMT.TEMP_ACCOUNT 
	public static final String SELECT__VI_ACCOUNT = 
			"SELECT " +
				"BRANCH, " +
				"CIF, " +
				"ACCOUNT, " +
				"SUFIX, " +
				"ACCOUNT_TYPE, " +
				"ACCOUNT_OPEN, " +
				"ACCOUNT_CLOSED, " +
				"REKENING_TYPE " +
			"FROM " + Constant.DWH_VW_ACCOUNT;
	
	// Copy data from DWH VI_ADDRESS to CMT.TEMP_ADDRESS by CIF
	public static final String SELECT__VI_ADDRESS = 
			"SELECT " +
				"CIF, " +
				"ADDRESS_TYPE, " +
				"ADDRESS1, " +
				"ADDRESS2, " +
				"ADDRESS3, " +
				"ADDRESS4, " +
				"ADDRESS5, " +
				"POST_CODE " +
			"FROM " + Constant.DWH_VW_ADDRESS + " WHERE CIF = ?";
	
	// select * from VI_CMT_M_COUNTRY
	public static final String SELECT__VI_COUNTRY = "SELECT COUNTRY_CODE, COUNTRY_NAME FROM " + Constant.DWH_VW_COUNTRY;
	
	// select * from VI_CMT_M_CST_TYPE
	public static final String SELECT__VI_CST_TYPE = "SELECT CUSTOMER_TYPE, CUSTOMER_DESCR FROM " + Constant.DWH_VW_CST_TYPE;
	
	// select * from VI_CMT_M_ACCOUNT_TYPE
	public static final String SELECT__VI_ACC_TYPE = "SELECT ACCOUNT_TYPE, ACCOUNT_DESCR FROM " + Constant.DWH_VW_ACC_TYPE;
	
	
}